Apache ActiveMQ ™ -- JMS Bridge With Oracle AQ

Using ActiveMQ > User Submitted Configurations > JMS Bridge With Oracle AQ

Example of a configuration that shows how to connect to Oracle AQ queues and topics.

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS\_LIST ....... (SERVICE\_NAME = myDbService))) jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS\_LIST ....... (SERVICE\_NAME = myDbService))) foo bar foo bar

If you run in an OSGi environment such as ServiceMix 4 then take a look at this discussion how to install the OracleAQ Client in the OSGi container.

Oracle SQL code

You may need to setup OracleAQ, and here is a sample code

BEGIN DBMS_AQADM.CREATE_QUEUE_TABLE( queue_table => 'queue_message_table', queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE'); END;

BEGIN DBMS_AQADM.CREATE_QUEUE( queue_name => 'ORACLE_QUEUE', queue_table => 'queue_message_table'); END;

BEGIN DBMS_AQADM.START_QUEUE(queue_name => 'ORACLE_QUEUE'); END;

You can also find more information about OracleAQ and using JMS at: http://docs.oracle.com/cd/B13789_01/server.101/b10785/jm_exmpl.htm

results matching ""

    No results matching ""